Merge and Acquisition
Hi, I want to fetch the merge and acquisition data for a RIC where the RIC is as target not acquiror. Like I want to find that the RIC WTB.L (Whitbread PLC) is acquired by any another company. Is there a way where we can specify the RIC as target and find its acquiror company or is there any field for it. Please help me out ASAP.
Best Answer
-
It is easier to use the search functionality as mentioned by my colleague.
However, to use Eikon Data API, you need to use screener.
First, you need to retrieve the organization PermId of WTB.L and then use the PermId in the screener to filter the results by using the TR.MnATargetPermId field.
For example:
df, err = ek.get_data("WTB.L",fields=["TR.OrganizationID"])
OrgPermId = df["Organization PermID"].values[0]
screener_exp = 'SCREEN(U(IN(DEALS)), IN(TR.MnATargetPermId,"'+str(OrgPermId)+'"))'
deals, err = ek.get_data(
instruments=[screener_exp],
fields=['TR.MnASDCDealNumber',
'TR.MnAAnnDate',
'TR.MnARankDate',
'TR.MnARankValueIncNetDebt(Curn=USD,Scale=6)',
'TR.MnATarget,TR.MnATargetPermId',
'TR.MnAAcquiror',
'TR.MnAAcquirorPermId',
'TR.MnAAcquirorMacroInd',
'TR.MnAAcquirorMidInd',
'TR.MnAAcquirorNation']
)
dealsThe output is:
You use the Data Item Browser tool to search for available fields.
0
Answers
-
Hi @vishnu01 ,
Thank you for you question. Below I have tried to bullt a quiery using our search capabilities which hopefully returns the data you are after:
MnA = rd.discovery.search(
view = rd.discovery.Views.DEALS_MERGERS_AND_ACQUISITIONS,
query = 'WTB.L*',
filter = "TargetRIC eq '*WTB.L*'",
select = 'TransactionAnnouncementDate,TargetRIC, TargetCompanyName, AcquirerCompanyName, TargetMidIndustry, TargetMidIndustry, RCSAcquirerCountryName',
order_by = 'TransactionAnnouncementDate desc',
top = 1000)
MnAFor more questions how to use search and find the best way to find teh properties you are after I would advice looking into this and this articles.
Hope this helps, happy to answer any follow on question re the quiery
Best regards,
Haykaz
1 -
Hi, I'm using the Refinitiv eikon library to fetch the data. can you please provide me the code using eikon.0
-
Thank you so much for the quick response. Is there any tutorial or documentation regarding the screener. How to use it and how to create formulas and all.
0 -
The above code is not supporting for SDate and EDate parameters. If i want to get the data in specific range then how can I get it. And is it possible without using the screener we can get this data ?0
-
It is the same formula generated by the Screener app, as mentioned in this article.
You can add other conditions in the screener formula, such as the TR.MnAAnnDate field. For example:
df, err = ek.get_data("WTB.L",fields=["TR.OrganizationID"])
OrgPermId = df["Organization PermID"].values[0]
screener_exp = 'SCREEN(U(IN(DEALS)), BETWEEN(TR.MnAAnnDate,20190201,20231012), IN(TR.MnATargetPermId,"'+str(OrgPermId)+'"))'
deals, err = ek.get_data(
instruments=[screener_exp],
fields=['TR.MnASDCDealNumber',
'TR.MnAAnnDate',
'TR.MnARankDate',
'TR.MnARankValueIncNetDebt(Curn=USD,Scale=6)',
'TR.MnATarget,TR.MnATargetPermId',
'TR.MnAAcquiror',
'TR.MnAAcquirorPermId',
'TR.MnAAcquirorMacroInd',
'TR.MnAAcquirorMidInd',
'TR.MnAAcquirorNation']
)
dealsYou may contat the helpdesk support directly via MyRefinitiv to get the valid screener formula that suits your requirments.
As far as I know, we can get this data by using the RD search or screener.
However, you may also ask the helpdesk support team to verify if the =TR formula in the Eikon Excel can be used to retrieve this data. If the =TR formula is available, we can apply the same parameters to the ek.get_data method.
0 -
Thank you so much for the quick response.
is there any field where we can find how many shares investors would get in acquiring company for every share of target company
0 -
I also want to add
'TR.DealStatus','TR.DealType','TR.DealSynopsis','TR.DealAnnouncementDate','TR.DealCurrency', 'TR.DealPricePerShare', 'TR.DealValueAnnounced', 'TR.DealCashAmount','TR.DealCashAmountType','TR.DealCashCurrency','TR.DealEquitySwapAmount','TR.DealEquitySwapAmountType','TR.DealClosedDate' fields in above formula. I added them but I'm not getting the correct data. Is there another name for them in MnA. I searched in DIB with TR.MnA but not found these fileds but in code creator merge and acquisition we have these fields. Please help me for that. please provide me the forumula with all those fields including above fields.
0 -
It is better to contact the content support team directly via MyRefinitiv to verify the formula or get the valid formula that suits your requirments.
You can ask the helpdesk support team for the =TR formula in Eikon Excel that can be used to retrieve this data. If the =TR formula is available, we can apply the same parameters to the ek.get_data method.
0 -
You can use the DSCREEN app to find the MnA fields.
0
Categories
- All Categories
- 6 AHS
- 37 Alpha
- 161 App Studio
- 4 Block Chain
- 4 Bot Platform
- 16 Connected Risk APIs
- 47 Data Fusion
- 30 Data Model Discovery
- 608 Datastream
- 1.3K DSS
- 577 Eikon COM
- 4.9K Eikon Data APIs
- 7 Electronic Trading
- Generic FIX
- 7 Local Bank Node API
- Trading API
- 2.7K Elektron
- 1.3K EMA
- 236 ETA
- 519 WebSocket API
- 33 FX Venues
- 10 FX Market Data
- 1 FX Post Trade
- 1 FX Trading - Matching
- 12 FX Trading – RFQ Maker
- 5 Intelligent Tagging
- 2 Legal One
- 20 Messenger Bot
- 2 Messenger Side by Side
- 9 ONESOURCE
- 7 Indirect Tax
- 59 Open Calais
- 264 Open PermID
- 39 Entity Search
- 2 Org ID
- PAM
- PAM - Logging
- 8.4K Private Comments
- 6 Product Insight
- Project Tracking
- ProView
- ProView Internal
- 20 RDMS
- 1.4K Refinitiv Data Platform
- 367 Refinitiv Data Platform Libraries
- 3 Refinitiv Due Diligence
- LSEG Due Diligence Portal API
- 3 Refinitiv Due Dilligence Centre
- Rose's Space
- 1.1K Screening
- 18 Qual-ID API
- 13 Screening Deployed
- 23 Screening Online
- 10 World-Check Customer Risk Screener
- 990 World-Check One
- 44 World-Check One Zero Footprint
- 45 Side by Side Integration API
- Test Space
- 3 Thomson One Smart
- 1.2K TR Internal
- Global Hackathon 2015
- 2 Specialists Who Code
- 10 TR Knowledge Graph
- 150 Transactions
- 142 REDI API
- 1.7K TREP APIs
- 4 CAT
- 21 DACS Station
- 117 Open DACS
- 1.1K RFA
- 103 UPA
- 172 TREP Infrastructure
- 224 TRKD
- 886 TRTH
- 5 Velocity Analytics
- 5 Wealth Management Web Services
- 59 Workspace SDK
- 9 Element Framework
- 5 Grid
- 13 World-Check Data File
- Yield Book Analytics
- 46 中文论坛